oracle check if index is used. There are any references about oracle check if index is used in here. you can look below.